
<html><HEAD>
<LINK REL=STYLESHEET HREF="default.css" TYPE="text/css">
<TITLE>
Using Open Client directory services</TITLE>
</HEAD>
<BODY>

<!-- Header -->
<p class="ancestor" align="right"><A HREF="connpbp40.htm">Previous</A>&nbsp;&nbsp;<A HREF="connpbp42.htm" >Next</A>
<!-- End Header -->
<A NAME="CCJCHAIE"></A><h1>Using Open Client directory services</h1>
<A NAME="TI776"></A><p>The Adaptive Server interfaces provide several DBParm parameters
that support Open Client 11.1.x or later network-based directory
services in your application. If you are using the required database,
directory services, and PowerBuilder software, you can build applications
that take advantage of Open Client directory services. </p>
<A NAME="TI777"></A><h2>What are Open Client directory services?</h2>
<A NAME="TI778"></A><p>Open Client 11.1.x or later <strong>directory services</strong> allow
you to use a supported third-party directory services product (such
as the Windows Registry) as your directory service provider. Directory
services provide centralized control and administration of the network
entities (such as users, servers, and printers) in your environment. </p>
<A NAME="CCJBDCEB"></A><h2>Requirements for using Open Client directory services</h2>
<A NAME="TI779"></A><p>For you to use Open Client directory services in your application, <i>all
of the following must be true</i>:<A NAME="TI780"></A>
<ul>
<li class=fi>You are accessing an Adaptive Server database server
using Open Client Client-Library (CT-Lib) 11.x or later software</li>
<li class=ds>You have the required Sybase-supported directory
service provider software and Sybase-supplied directory driver properly
installed and configured for your environment. Depending on your
operating system platform, examples of supported security mechanisms
include the Windows Registry and Distributed Computing Environment
Cell Directory Services (DCE/CDS).<br>
For information about the directory service
providers and operating system platforms that Sybase has tested
with Open Client directory services, see the Open Client documentation.<br></li>
<li class=ds>You must be able to access a secure Adaptive Server
server using Open Client 11.1.x or later software from outside PowerBuilder.<br>
To verify the connection, use a tool such as <ACRONYM title = "I sequel" >ISQL</ACRONYM> or <ACRONYM title = "sequel" >SQL</ACRONYM> Advantage
to make sure you can connect to the server and log in to the database
with the same connection parameters and directory service options
you plan to use in your PowerBuilder application.<br></li>
<li class=ds>You are using the ASE or SYC Adaptive Server interface
to access the database.</li>
<li class=ds>You must use the correct syntax as required by your
directory service provider when specifying the server name in a
database profile or PowerBuilder application script. Different providers
require different syntax based on their format for specifying directory
entry names.<br>
For information and examples for different
directory service providers, see <A HREF="connpbp41.htm#CCJDIFGI">"Specifying the server name
with Open Client directory services"</A>.<br></li>
<li class=ds>You have set the Release DBParm to 11 or higher
to specify that your application should use the behavior of the
appropriate version of the Open Client CT-Lib software.<br>
For instructions, see Release database parameter
in the online Help. <br></li>
<li class=ds>The directory service provider and driver you are
using must support the service requested by the DBParm.
</li>
</ul>
</p>
<A NAME="CCJDIFGI"></A><h2>Specifying the server name with Open Client directory services</h2>
<A NAME="TI781"></A><p>When you are using Open Client directory services in a PowerBuilder application,
you must use the syntax required by your directory service provider
when specifying the server name in a database profile or PowerBuilder
application script to access the database.</p>
<A NAME="TI782"></A><p>Different directory service providers require different syntax
based on the format they use for specifying directory entry names.
Directory entry names can be fully qualified or relative to the
default (active) Directory Information Tree base (DIT base) specified
in the Open Client/Server&#153; configuration utility.</p>
<A NAME="TI783"></A><p>The <strong>DIT base</strong> is the starting node for
directory searches. Specifying a DITbase is analogous to setting
a current working directory for UNIX or MS-DOS file systems. (You
can specify a nondefault DIT base with the DS_DitBase DBParm.
For information, see DS_DitBase in the online Help.)</p>
<A NAME="TI784"></A><h4>Windows registry server name example</h4>
<A NAME="TI785"></A><p>This example shows typical server name syntax if your directory
service provider is the Windows registry.<p><PRE> Node name: SALES:software\sybase\server\SYS12<br>DIT base: SALES:software\sybase\server<br>Server name: SYS12</PRE></p>
<A NAME="TI786"></A><p><img src="images/proc.gif" width=17 height=17 border=0 align="bottom" alt="Steps"> To specify the server name in a database profile:</p>
<ol><li class=fi><p>Type the following in the Server box on
the Connection tab in the Database Profile Setup dialog box. Do <i>not</i> start
the server name with a backslash (\).<p><PRE> SYS12</PRE></p></li></ol>
<br><A NAME="TI787"></A><p><img src="images/proc.gif" width=17 height=17 border=0 align="bottom" alt="Steps"> To specify the server name in a PowerBuilder application
script:</p>
<ol><li class=fi><p>Type the following. Do<i> not</i> start
the server name with a backslash (\).<p><PRE> SQLCA.ServerName = "SYS12"</PRE></p><p>If you specify a value in the Server box in your database
profile, this syntax displays on the Preview tab in the Database
Profile Setup dialog box. You can copy the syntax from the Preview
tab into your script.</p></li></ol>
<br><A NAME="TI788"></A><h4>DCE/CDS server name example</h4>
<A NAME="TI789"></A><p>This example shows typical server name syntax if your directory
service provider is Distributed Computing Environment Cell Directory
Services (DCE/CDS).<p><PRE> Node name: /.../boston.sales/dataservers/sybase/SYS12<br>DIT base: /../boston.sales/dataservers<br>Server name: sybase/SYS12</PRE></p>
<A NAME="TI790"></A><p><img src="images/proc.gif" width=17 height=17 border=0 align="bottom" alt="Steps"> To specify the server name in a database profile:</p>
<ol><li class=fi><p>Type the following in the Server box on
the Connection tab in the Database Profile Setup dialog box. Do <i>not</i> start
the server name with a slash (/).<p><PRE> sybase/SYS12</PRE></p></li></ol>
<br><A NAME="TI791"></A><p><img src="images/proc.gif" width=17 height=17 border=0 align="bottom" alt="Steps"> To specify the server name in a PowerBuilder application
script:</p>
<ol><li class=fi><p>Type the following. Do<i> not</i> start
the server name with CN=.</p><p><p><PRE> SQLCA.ServerName = "SYS12"</PRE></p><p>If you specify a value in the Server box in your database
profile, this syntax displays on the Preview tab in the Database
Profile Setup dialog box. You can copy the syntax from the Preview
tab into your script.</p></li></ol>
<br><A NAME="TI792"></A><h2>Directory services DBParm parameters</h2>
<A NAME="TI793"></A><p>If you have met the requirements described in <A HREF="connpbp41.htm#CCJBDCEB">"Requirements for using Open
Client directory services"</A>, you can set
the directory services DBParms in a database profile for your
connection or in a PowerBuilder application script.</p>
<A NAME="TI794"></A><p>The following DBParms correspond to Open Client 11.1.x
or later directory services connection parameters:<A NAME="TI795"></A>
<ul>
<li class=fi>DS_Alias</li>
<li class=ds>DS_Copy</li>
<li class=ds>DS_DitBase</li>
<li class=ds>DS_Failover</li>
<li class=ds>DS_Password (Open Client 12.5 or later)</li>
<li class=ds>DS_Principal</li>
<li class=ds>DS_Provider</li>
<li class=ds>DS_TimeLimit
</li>
</ul>
</p>
<A NAME="TI796"></A><p>For instructions on setting these DBParms,
see their descriptions in the online Help.</p>

